Category: MSSQL
MSSQL -> MySQL - Performance Issues
I've recently moved from a MSSQL environment to a MySQL environment. Are there any changes I might look at for performance improvements?
For example, the original programmer used a lot of joins. In general, is it faster to use a join or 2 select queries when getting small sets from a large database?
Any help is appreciated. Thanks.